package com.main.tripplanner;


import java.text.DecimalFormat;
import java.util.Random;
//import org.slf4j.Logger;
//import org.slf4j.LoggerFactory;


public class Start {
//	private static final Logger logger = LoggerFactory.getLogger(Start.class);
	
	public static void main(String[] args) {
		Random rnd = new Random();
		StringBuffer sb = new StringBuffer();
		String cities = "Lorem,ipsum,dolor,sit,amet,consectetur,adipiscing,elit,Phasellus,aliquet,vel,est,a,tempor,Maecenas,varius,dui,nec,lectus,tempor,suscipit,Ut,volutpat,quis,metus,in,iaculis,Fusce,elementum,felis,sed,tellus,consectetur,scelerisque,Aliquam,erat,volutpat,Mauris,dictum,felis,ac,tortor,dictum,auctor,vel,et,sem,Praesent,ultricies,dignissim,neque,eu,gravida,Maecenas,eu,tincidunt,massa,Morbi,a,aliquet,dui,Nunc,at,euismod,leo,Curabitur,aliquam,turpis,tellus,malesuada,vulputate,nibh,placerat,a,Integer,sed,lectus,velit,Donec,a,magna,non,elit,blandit,ullamcorper,at,nec,lectus,Donec,bibendum,felis,vitae,enim,laoreet,mollis,sit,amet,eu,erat,Proin,nisi,dolor,dignissim,in,fermentum,semper,semper,in,urna,In,ipsum,metus,egestas,at,lacinia,ut,pellentesque,vel,erat,Integer,dolor,erat,viverra,eu,arcu,ut,vehicula,aliquet,dui,dasbdkm,edsn,dbsaiud,dsahodas,vcpio,v-p,dhasodi,agbisab,cdbsxcks,fnsedkf,ewdo,feowifwe,fdheof,qodej,qwewr,fdas,dfsg,fhhh,das,fd,sf,ds,fsd,fsd,fsd,fgf,hth";
		String[] citiesArray = cities.split(",");
		int j=0;
		for(int i=154; i<3000; i++){
			String insert = "insert into attractions values (" + (i+1) + ",'" + citiesArray[j] + "'," 
		+ new DecimalFormat("0.00").format(Math.random() * 2) + "," + new DecimalFormat("0.00").format(Math.random() * 10) 
		+ "," +  rnd.nextInt(30) + "," + (rnd.nextInt(4)) + "," + (rnd.nextInt(148) +1) + ");\n";
			sb.append(insert);
			if(j==citiesArray.length-1){
				j=0;
			}
			else{
				j++;
			}
		}
		System.out.println(sb);
	}
}